{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Planning Input","Planning Summary","Taxable Social Security Income","Adjustments","Deductions and Exemptions","Tax Calculations","Credits"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":37,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Planning Input","index":0,"n_rows":86,"n_cols":5,"rows_kept":86,"cut":false,"hidden":false,"merged":[[12,3,12,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[67,0,67,4],[71,0,71,4],[81,0,81,4],[31,0,31,4],[48,0,48,4],[5,1,5,2],[5,3,5,4],[14,0,14,4],[13,0,13,4],[6,1,6,2]]}
["[Name]"]
["2008 Year-End Tax Planning: Planning Input"]
["[Date]"]
[]
["You do not need to enter anything into shaded cells.",null,null,null,"CONFIDENTIAL"]
["Filing Status and Exemptions",2007,null,2008]
["Filing status","Married Filing Separately",null,{"$f":"CY_FS","v":"Married Filing Separately"}]
["If married filing separately, live with spouse at any time during year?","No",null,"Yes"]
["Taxpayer's age at end of year",37,null,{"$f":"B9+1","v":38}]
["Spouse's age at end of year",36,null,{"$f":"IF(B10<>0, B10+1, 0)","v":37}]
["Taxpayer, spouse, or both blind?","No",null,{"$f":"CY_Blind","v":"No"}]
["Number of dependents",1,null,{"$f":"B12","v":1}]
["Number of dependents eligible for child tax credit",1,null,{"$f":"B13","v":1}]
[]
["Income"]
["Wages, salaries, tips, etc.",null,42000,null,{"$f":"C16","v":42000}]
["Tax-exempt interest",null,null,{"$f":"B17","v":0}]
["Taxable interest and ordinary dividends",null,25,null,{"$f":"C18","v":25}]
["Qualified dividends",null,null,{"$f":"B19","v":0}]
["Taxable state refunds",null,null,null,0]
["Business income (or loss)",null,57000,null,{"$f":"C21","v":57000}]
["Capital gain (or loss)",null,-3000,null,-3000]
["Other gains (or losses)",null,null,null,0]
["Taxable IRA and pension distributions",null,null,null,0]
["Rental real estate, royalties, partnerships, S corporations, etc.",null,-2016,null,{"$f":"C25","v":-2016}]
["Unemployment compensation",null,null,null,{"$f":"C26","v":0}]
["Social Security benefits: Total",null,null,{"$f":"B27","v":0}]
["Social Security benefits: Taxable",null,{"$f":"'Taxable Social Security Income'!D33","v":0},null,{"$f":"'Taxable Social Security Income'!F33","v":0}]
["Other income",null,null,null,{"$f":"C29","v":0}]
["Total income",null,{"$f":"SUM(C16:C26)+C28+C29","v":94009},null,{"$f":"SUM(E16:E26)+E28+E29","v":94009}]
[]
["Adjustments to Income"]
["Taxpayer's traditional IRA contribution",null,null,{"$f":"B33","v":0}]
["Taxpayer covered by retirement plan?","No",null,{"$f":"B34","v":"No"}]
["Spouse's traditional IRA contribution",null,null,{"$f":"B35","v":0}]
["Spouse covered by retirement plan?","No",null,{"$f":"B36","v":"No"}]
["IRA deduction",null,{"$f":"IF(B27>0, 0, Adjustments!C21+Adjustments!D21)","v":0},null,{"$f":"IF(D27>0, 0, Adjustments!F21+Adjustments!G21)","v":0}]
["Tuition and fees paid",4000,null,{"$f":"B38","v":4000}]
["Tuition and fees deduction",null,{"$f":"Adjustments!C62","v":0},null,{"$f":"Adjustments!E62","v":0}]
["Health savings account deduction",null,3000,null,{"$f":"C40","v":3000}]
["Moving expenses",null,null,null,{"$f":"C41","v":0}]
["One-half of self-employment tax",null,{"$f":"ROUND(0.5*B70,0)","v":4090},null,{"$f":"0.5*D70","v":4090}]
["Self-employed health insurance deduction",null,null,null,{"$f":"C43","v":0}]
["Self-employed SEP, SIMPLE, and qualified plans",null,null,null,{"$f":"C44","v":0}]
["Other adjustments",null,null,null,{"$f":"C45","v":0}]
["Total adjustments",null,{"$f":"SUM(C37:C45)","v":7090},null,{"$f":"SUM(E37:E45)","v":7090}]
["Adjusted gross income",null,{"$f":"C30-C46","v":86919},null,{"$f":"E30-E46","v":86919}]
["Standard deduction",{"$f":"SUM('Deductions and Exemptions'!D20:D23)+SUM('Deductions and Exemptions'!E20:E23)+SUM('Deductions and Exemptions'!F20:F23)","v":4850},null,{"$f":"SUM('Deductions and Exemptions'!D27:D30)+SUM('Deductions and Exemptions'!E27:E30)+SUM('Deductions and Exemptions'!F27:F30)","v":5000}]
["Itemized Deductions"]
["Medical and dental expenses: Total",5544,null,{"$f":"B50","v":5544}]
["Medical and dental expenses: Deductible",null,{"$f":"IF(B50=0, 0, MAX(0, B50-(0.075*MAX(0, C47))))","v":0},null,{"$f":"IF(D50=0, 0, MAX(0, D50-(0.075*MAX(0, 'Planning Input'!E47))))","v":0}]
["Real estate taxes",null,0,null,{"$f":"C52","v":0}]
["State and local taxes",null,5000,null,5000]
["Other taxes",null,null,null,0]
["Home mortgage interest and points",null,6987,null,6987]
["Investment interest",null,null,null,0]
["Gifts to charity",null,null,null,0]
["Casualty or theft loss(es)",null,null,null,0]
["Miscellaneous deductions not subject to 2% limitation",null,null,null,0]
["Miscellaneous deductions subject to 2% limitation: Total",350,null,{"$f":"B60","v":350}]
["Miscellaneous deductions subject to 2% limitation: Deductible",null,{"$f":"MAX(0,B60-(0.02*MAX(0, C47)))","v":0},null,{"$f":"MAX(0, D60-(0.02*MAX(0, 'Planning Input'!E47)))","v":0}]
["Total itemized deductions",null,{"$f":"SUM(C51:C59)+C61","v":11987},null,{"$f":"SUM(E51:E59)+E61","v":11987}]
["Allowed itemized deductions",null,{"$f":"'Deductions and Exemptions'!C16","v":11520},null,{"$f":"'Deductions and Exemptions'!E16","v":11568.68}]
["Itemized or standard deduction",null,{"$f":"MAX(B48,C63)","v":11520},null,{"$f":"MAX(D48,E63)","v":11568.68}]
["Exemptions",null,{"$f":"'Deductions and Exemptions'!C44","v":6200},null,{"$f":"'Deductions and Exemptions'!E44","v":6400}]
["Taxable income",null,{"$f":"MAX(0, ROUND(C47-C64-C65,0))","v":69199},null,{"$f":"MAX(0, ROUND(E47-E64-E65,0))","v":68950}]
[]
["Tax"]
["Income tax",14354,null,{"$f":"'Tax Calculations'!I109","v":14172}]
["Self-employment tax",{"$f":"'Tax Calculations'!C16","v":8180},null,{"$f":"'Tax Calculations'!E16","v":8180}]
["Total tax",null,{"$f":"SUM(B69:B70)","v":22534},null,{"$f":"SUM(D69:D70)","v":22352}]
["Credits"]
["Foreign tax credit",null,null,{"$f":"B73","v":0}]
["Credit for child and dependent care expenses",null,null,{"$f":"B74","v":0}]
["Credit for the elderly or the disabled",null,null,{"$f":"B75","v":0}]
["Education credits",null,null,{"$f":"B76","v":0}]
["Retirement savings contributions credit",null,null,{"$f":"B77","v":0}]
["Child tax credit",{"$f":"Credits!C14","v":0},null,{"$f":"Credits!E14","v":0}]
["Other credits",1301,null,{"$f":"B79","v":1301}]
["Total credits",null,{"$f":"SUM(B73:B79)","v":1301},null,{"$f":"SUM(D73:D79)","v":1301}]
["Tax after credits",null,{"$f":"C71-C80","v":21233},null,{"$f":"E71-E80","v":21051}]
["Payments"]
["Withholding",null,null,{"$f":"B83","v":0}]
["Estimated tax payments",null,null,{"$f":"B84","v":0}]
["Total payments",null,{"$f":"B83+B84","v":0},null,{"$f":"D83+D84","v":0}]
["Refund (balance due)",null,{"$f":"C85-C81","v":-21233},null,{"$f":"E85-E81","v":-21051}]

{"sheet":"Planning Summary","index":1,"n_rows":46,"n_cols":3,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Planning Input'!A1","v":"[Name]"}]
["2008 Year-End Tax Planning: Planning Summary"]
[{"$f":"'Planning Input'!A3","v":"[Date]"}]
[]
["Gray cells are calculated for you. You do not need to enter anything in them.",null,"CONFIDENTIAL"]
["Filing Status and Exemptions",2007,2008]
["Filing status",{"$f":"CY_FS","v":"Married Filing Separately"},{"$f":"NY_FS","v":"Married Filing Separately"}]
["Number of dependents",{"$f":"'Planning Input'!B12","v":1},{"$f":"'Planning Input'!D12","v":1}]
["Income"]
["Wages, salaries, tips, etc.",{"$f":"'Planning Input'!C16","v":42000},{"$f":"'Planning Input'!E16","v":42000}]
["Taxable interest and ordinary dividends",{"$f":"'Planning Input'!C18","v":25},{"$f":"'Planning Input'!E18","v":25}]
["Taxable state refunds",{"$f":"'Planning Input'!C20","v":0},{"$f":"'Planning Input'!E20","v":0}]
["Business income (or loss)",{"$f":"'Planning Input'!C21","v":57000},{"$f":"'Planning Input'!E21","v":57000}]
["Capital gain (or loss)",{"$f":"'Planning Input'!C22","v":-3000},{"$f":"'Planning Input'!E22","v":-3000}]
["Other gains (or losses)",{"$f":"'Planning Input'!C23","v":0},{"$f":"'Planning Input'!E23","v":0}]
["Taxable IRA and pension distributions",{"$f":"'Planning Input'!C24","v":0},{"$f":"'Planning Input'!E24","v":0}]
["Rental real estate, partnerships, S corporations",{"$f":"'Planning Input'!C25","v":-2016},{"$f":"'Planning Input'!E25","v":-2016}]
["Unemployment compensation",{"$f":"'Planning Input'!C26","v":0},{"$f":"'Planning Input'!E26","v":0}]
["Social Security benefits: Taxable",{"$f":"'Planning Input'!C28","v":0},{"$f":"'Planning Input'!E28","v":0}]
["Other income",{"$f":"'Planning Input'!C29","v":0},{"$f":"'Planning Input'!E29","v":0}]
["Total income",{"$f":"'Planning Input'!C30","v":94009},{"$f":"'Planning Input'!E30","v":94009}]
["Adjustments to Income"]
["IRA deduction",{"$f":"'Planning Input'!C37","v":0},{"$f":"'Planning Input'!E37","v":0}]
["One-half of self-employment tax",{"$f":"'Planning Input'!C42","v":4090},{"$f":"'Planning Input'!E42","v":4090}]
["Other adjustments",{"$f":"'Planning Input'!C39+'Planning Input'!C40+'Planning Input'!C41+'Planning Input'!C43+'Planning Input'!C44+'Planning Input'!C45","v":3000},{"$f":"'Planning Input'!E39+'Planning Input'!E40+'Planning Input'!E41+'Planning Input'!E43+'Planning Input'!E44+'Planning Input'!E45","v":3000}]
["Total adjustments",{"$f":"'Planning Input'!C46","v":7090},{"$f":"'Planning Input'!E46","v":7090}]
["Adjusted gross income",{"$f":"'Planning Input'!C47","v":86919},{"$f":"'Planning Input'!E47","v":86919}]
["Deductions"]
["Standard deduction",{"$f":"'Planning Input'!B48","v":4850},{"$f":"'Planning Input'!D48","v":5000}]
["Allowed itemized deductions",{"$f":"'Planning Input'!C63","v":11520},{"$f":"'Planning Input'!E63","v":11568.68}]
["Larger of itemized or standard deduction",{"$f":"'Planning Input'!C64","v":11520},{"$f":"'Planning Input'!E64","v":11568.68}]
["Exemptions",{"$f":"'Planning Input'!C65","v":6200},{"$f":"'Planning Input'!E65","v":6400}]
["Taxable Income",{"$f":"CY_TaxIncome","v":69199},{"$f":"NY_TaxIncome","v":68950}]
["Tax"]
["Income tax",{"$f":"'Tax Calculations'!F109","v":14219},{"$f":"'Tax Calculations'!I109","v":14172}]
["Self-employment tax",{"$f":"'Tax Calculations'!C16","v":8180},{"$f":"'Tax Calculations'!E16","v":8180}]
["Total tax",{"$f":"SUM(B35:B36)","v":22399},{"$f":"SUM(C35:C36)","v":22352}]
["Credits",{"$f":"SUM('Planning Input'!B73:B79)","v":1301},{"$f":"SUM('Planning Input'!D73:D78)","v":0}]
["Tax after credits",{"$f":"B37-B38","v":21098},{"$f":"C37-C38","v":22352}]
["Withholding",{"$f":"'Planning Input'!B83","v":0},{"$f":"'Planning Input'!D83","v":0}]
["Estimated tax payments",{"$f":"'Planning Input'!B84","v":0},{"$f":"'Planning Input'!D84","v":0}]
["Refund (balance due)",{"$f":"B40+B41-B39","v":-21098},{"$f":"C40+C41-C39","v":-22352}]
[]
["Effective tax rate",{"$f":"'Tax Calculations'!C112","v":0.20547984797468172},{"$f":"'Tax Calculations'!E112","v":0.20554024655547498}]
["Marginal tax rate",{"$f":"CY_Marginal","v":0.28000000000000003},{"$f":"NY_Marginal","v":0.28000000000000003}]
[{"$f":"IF(B36=0, \"\", \"Marginal tax rate: Self-employment income\")","v":"Marginal tax rate: Self-employment income"},{"$f":"IF(B36 = 0,\"\", CY_Marginal+'Tax Calculations'!C9+'Tax Calculations'!C10)","v":0.43300000000000005},{"$f":"IF(B36=0, \"\", NY_Marginal+'Tax Calculations'!E9+'Tax Calculations'!E10)","v":0.43300000000000005}]

{"sheet":"Taxable Social Security Income","index":2,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[14,2,15,3],[19,2,22,3],[14,4,15,5],[19,4,22,5],[4,0,4,2],[0,0,0,1],[6,2,6,3],[6,4,6,5],[2,0,2,1],[25,4,26,5],[25,2,26,3],[14,0,16,0],[20,0,23,0],[25,0,27,0]]}
[{"$f":"'Planning Input'!A1","v":"[Name]"}]
["2008 Year-End Tax Planning: Taxable Social Security Income"]
[{"$f":"'Planning Input'!A3","v":"[Date]"}]
[]
["NOTE: If client received social security and made traditional IRA contributions, see IRS Publication 590."]
["Gray cells are calculated for you. You do not need to enter anything in them.",null,null,null,null,"CONFIDENTIAL"]
[null,null,2007,null,2008]
[1,"Total Social Security income received",null,{"$f":"'Planning Input'!B27","v":0},null,{"$f":"'Planning Input'!D27","v":0}]
[2,"One-half of Social Security income received",null,{"$f":"0.5*D8","v":0},null,{"$f":"0.5*F8","v":0}]
[3,"Income as prescribed",null,{"$f":"IF(D8=0, 0, 'Planning Input'!C16+'Planning Input'!C18+'Planning Input'!C20+'Planning Input'!C21+'Planning Input'!C22+'Planning Input'!C23+'Planning Input'!C24+'Planning Input'!C25+'Planning Input'!C26+'Planning Input'!C29)","v":0},null,{"$f":"IF(F8=0, 0, 'Planning Input'!E16+'Planning Input'!E18+'Planning Input'!E20+'Planning Input'!E21+'Planning Input'!E22+'Planning Input'!E23+'Planning Input'!E24+'Planning Input'!E25+'Planning Input'!E26+'Planning Input'!E29)","v":0}]
[4,"Tax-exempt interest",null,{"$f":"'Planning Input'!B17","v":0},null,{"$f":"'Planning Input'!D17","v":0}]
[5,"Sum of lines 2, 3, and 4 above",null,{"$f":"SUM(D9:D11)","v":0},null,{"$f":"SUM(F9:F11)","v":0}]
[6,"Certain adjustments from 1040 (not including IRA)",null,{"$f":"IF(D8=0, 0, 'Planning Input'!C40+'Planning Input'!C41+'Planning Input'!C42+'Planning Input'!C43+'Planning Input'!C45)","v":0},null,{"$f":"IF(F8=0, 0, 'Planning Input'!E40+'Planning Input'!E41+'Planning Input'!E42+'Planning Input'!E43+'Planning Input'!E45)","v":0}]
[7,"Provisional income",null,{"$f":"D12-D13","v":0},null,{"$f":"F12-F13","v":0}]
[8,"Enter (a) $32,000 if married filing jointly, or"]
[null,"(b) $0 if married filing separately and lived with spouse at any time during year, or"]
[null,"(c) $25,000 if all others",null,{"$f":"IF(D8=0, 0, IF(CY_FS=\"Married Filing Jointly\", 32000, IF(CY_FS<>\"Married Filing Separately\", 25000, IF('Planning Input'!B8=\"No\", 25000, 0))))","v":0},null,{"$f":"IF(F8=0, 0, IF(NY_FS=\"Married Filing Jointly\", 32000, IF(NY_FS<>\"Married Filing Separately\", 25000, IF('Planning Input'!D8=\"No\", 25000, 0))))","v":0}]
[9,"Subtract line 8 from line 7",null,{"$f":"D14-D17","v":0},null,{"$f":"F14-F17","v":0}]
[10,"Smaller of line 2, or 50% of line 9",null,{"$f":"MIN(D9, 0.5 * D18)","v":0},null,{"$f":"MIN(F9, 0.5 * F18)","v":0}]
[]
[11,"Enter the smaller of line 10 or:"]
[null,"(a) $6,000 if married filing jointly, or"]
[null,"(b) $0 if married filing separately and lived with spouse at any time during year, or"]
[null,"(c) $4,500 if all others",null,{"$f":"IF(CY_FS=\"Married Filing Jointly\",IF(D14<44001,0,6000),IF(D14<34001,0,MIN(D19,IF(CY_FS<>\"Married Filing Separately\",4500,IF('Planning Input'!B8=\"No\",4500,0)))))","v":0},null,{"$f":"IF(NY_FS=\"Married Filing Jointly\",IF(F14<44001,0,6000),IF(F14<34001,0,MIN(F19,IF(NY_FS<>\"Married Filing Separately\",4500,IF('Planning Input'!D8=\"No\",4500,0)))))","v":0}]
[12,"Amount from line 7",null,{"$f":"IF(CY_FS=\"Married Filing Jointly\",IF(D14<44001,0,D14),IF(D14<34001,0,D14))","v":0},null,{"$f":"IF(NY_FS=\"Married Filing Jointly\",IF(F14<44001,0,F14),IF(F14<34001,0,F14))","v":0}]
[13,"Enter (a) $44,000 if married filing jointly, or"]
[null,"(b) $0 if married filing separately and lived with spouse at any time during year, or"]
[null,"(c) $34,000, all others",null,{"$f":"IF(CY_FS = \"Married Filing Jointly\", IF(D14<44001, 0, 44000), IF(D14<34001, 0, MIN(D23,IF(CY_FS<>\"Married Filing Separately\", 34000,IF('Planning Input'!B8=\"No\", 34000, 0)))))","v":0},null,{"$f":"IF(NY_FS = \"Married Filing Jointly\", IF(F14<44001, 0, 44000), IF(F14<34001, 0, MIN(F23,IF(NY_FS<>\"Married Filing Separately\", 34000,IF('Planning Input'!D8=\"No\", 34000, 0)))))","v":0}]
[14,"Subtract line 13 from line 12",null,{"$f":"MAX(0, D25-D28)","v":0},null,{"$f":"MAX(0, F25-F28)","v":0}]
[15,"Multiply line 14 by 0.85",null,{"$f":"D29*0.85","v":0},null,{"$f":"F29*0.85","v":0}]
[16,"Add line 11 and line 15",null,{"$f":"D24+D30","v":0},null,{"$f":"F24+F30","v":0}]
[17,"Multiply line 1 by 0.85",null,{"$f":"IF(CY_FS = \"Married Filing Jointly\", IF(D14<44001, 0, D8*0.85),IF(D14<34001, 0, D8*0.85))","v":0},null,{"$f":"IF(NY_FS = \"Married Filing Jointly\", IF(F14<44001, 0, F8*0.85),IF(F14<34001, 0, F8*0.85))","v":0}]
[18,"Taxable Social Security income",null,{"$f":"IF(CY_FS = \"Married Filing Jointly\", IF(D14<44001, MAX(0, D19), MAX(0, MIN(D31,D32))),IF(D14<34001, MAX(0, D19), MAX(0, MIN(D31,D32))))","v":0},null,{"$f":"IF(NY_FS = \"Married Filing Jointly\", IF(F14<44001, MAX(0, F19), MAX(0, MIN(F31,F32))),IF(F14<34001, MAX(0, F19), MAX(0, MIN(F31,F32))))","v":0}]

{"sheet":"Adjustments","index":3,"n_rows":67,"n_cols":7,"rows_kept":67,"cut":false,"hidden":false,"merged":[[6,1,6,3],[6,4,6,6],[63,1,63,2],[63,3,63,4],[52,1,52,2],[52,3,52,4],[46,1,46,2],[46,3,46,4]]}
[{"$f":"'Planning Input'!A1","v":"[Name]"}]
["2008 Year-End Tax Planning: Adjustments"]
[{"$f":"'Planning Input'!A3","v":"[Date]"}]
[]
["NOTE: If client received Social Security income and made traditional IRA contributions, see IRS Publication 590."]
["You do not need to enter anything into shaded cells.",null,null,null,null,null,"CONFIDENTIAL"]
[null,2007,null,null,2008]
["IRA Deduction",null,"Taxpayer IRA","Spouse IRA",null,"Taxpayer IRA","Spouse IRA"]
["Traditional IRA contributions",null,{"$f":"'Planning Input'!B33","v":0},{"$f":"'Planning Input'!B35","v":0},null,{"$f":"'Planning Input'!D33","v":0},{"$f":"'Planning Input'!D35","v":0}]
["Covered by retirement plan?",null,{"$f":"'Planning Input'!B34","v":"No"},{"$f":"'Planning Input'!B36","v":"No"},null,{"$f":"'Planning Input'!D34","v":"No"},{"$f":"'Planning Input'!D36","v":"No"}]
["Skip next five lines?",{"$f":"IF(CY_FS<>\"Married Filing Jointly\",IF(C10=\"No\",\"Yes\", \"No\"),IF(C10=\"No\", IF(D10 = \"No\", \"Yes\", \"No\"),\"No\"))","v":"Yes"},null,null,{"$f":"IF(NY_FS<>\"Married Filing Jointly\",IF(F10=\"No\",\"Yes\", \"No\"),IF(F10=\"No\", IF(G10 = \"No\", \"Yes\", \"No\"),\"No\"))","v":"Yes"}]
[]
["Amount from Maximum Income table (see below)",null,{"$f":"IF(B11=\"Yes\", 0, D25+D26+D28+D29+D30+D32+D33)","v":0},{"$f":"IF(CY_FS <> \"Married Filing Jointly\", 0, IF(B11=\"Yes\", 0, E28+E29+E30))","v":0},null,{"$f":"IF($E11=\"Yes\", 0, D36+D37+D39+D40+D41+D43+D44)","v":0},{"$f":"IF(NY_FS <> \"Married Filing Jointly\", 0,IF($E11=\"Yes\", 0, E39+E40+E41))","v":0}]
["Total income (not including Social Security income)",{"$f":"IF(B11=\"Yes\", 0, IF('Planning Input'!B27 > 0, 0, 'Planning Input'!C16+'Planning Input'!C18+'Planning Input'!C20+'Planning Input'!C21+'Planning Input'!C22+'Planning Input'!C23+'Planning Input'!C24+'Planning Input'!C25+'Planning Input'!C26+'Planning Input'!C29))","v":0},null,null,{"$f":"IF(E11=\"Yes\", 0, IF('Planning Input'!D27 > 0, 0, 'Planning Input'!E16+'Planning Input'!E18+'Planning Input'!E20+'Planning Input'!E21+'Planning Input'!E22+'Planning Input'!E23+'Planning Input'!E24+'Planning Input'!E25+'Planning Input'!E26+'Planning Input'!E29))","v":0}]
["Other adjustments to income",{"$f":"IF(B11=\"Yes\", 0, 'Planning Input'!C40+'Planning Input'!C41+'Planning Input'!C42+'Planning Input'!C43+'Planning Input'!C45)","v":0},null,null,{"$f":"IF(E11=\"Yes\", 0, 'Planning Input'!E40+'Planning Input'!E41+'Planning Input'!E42+'Planning Input'!E43+'Planning Input'!E45)","v":0}]
["Adjusted income to compare to maximum limits",null,{"$f":"B14-B15","v":0},{"$f":"IF(CY_FS <> \"Married Filing Jointly\", 0, B14-B15)","v":0},null,{"$f":"E14-E15","v":0},{"$f":"IF(NY_FS <> \"Married Filing Jointly\", 0, E14-E15)","v":0}]
["If adjusted income is less than the maximum income, difference",null,{"$f":"IF(C16<C13, C13-C16, 0)","v":0},{"$f":"IF(CY_FS <> \"Married Filing Jointly\", 0, IF(D16<D13, D13-D16, 0))","v":0},null,{"$f":"IF(F16<F13, F13-F16, 0)","v":0},{"$f":"IF(NY_FS <> \"Married Filing Jointly\", 0, IF(G16<G13, G13-G16, 0))","v":0}]
["Multiply by 30% (.30) (or by 35% (.35) if age 50 or older), not less than $200",null,{"$f":"IF(B11=\"Yes\", B51,IF(C17 = 0, 0, IF(C17<10000, IF(CY_TP_Age < 50, MAX(0.3*C17, 200),MAX(0.35*C17,200)),B51)))","v":3000},{"$f":"IF(CY_FS <> \"Married Filing Jointly\", 0, IF(B11=\"Yes\", C51, IF(D17<10000, IF(CY_SP_Age < 50, MAX(0.3*D17, 200),MAX(0.35*D17,200)), C51)))","v":0},null,{"$f":"IF(E11=\"Yes\", D51,IF(F17 = 0, 0, IF(F17<10000, IF(NY_TP_Age < 50, MAX(0.3*F17, 200),MAX(0.35*F17,200)),D51)))","v":4000},{"$f":"IF(NY_FS <>\"Married Filing Jointly\", 0, IF(E11=\"Yes\", E51, IF(G17<10000, IF(NY_SP_Age < 50, MAX(0.3*G17, 200),MAX(0.35*G17,200)), E51)))","v":0}]
["Earned income",{"$f":"'Planning Input'!C16+MAX(0, 'Planning Input'!C21)-'Planning Input'!C42-'Planning Input'!C44","v":94910},null,null,{"$f":"'Planning Input'!E16+MAX(0, 'Planning Input'!E21)-'Planning Input'!E42-'Planning Input'!E44","v":94910}]
[]
["Smallest of contribution, earned income, or maximum",null,{"$f":"IF('Planning Input'!B27>0,\"See Pub 590\",MIN(C18,B19,C9))","v":0},{"$f":"IF('Planning Input'!B27>0, 0, MIN(D18,B19,D9))","v":0},null,{"$f":"IF('Planning Input'!D27>0,\"See Pub 590\",MIN(F18,E19,F9))","v":0},{"$f":"IF('Planning Input'!E27>0, 0, MIN(G18,E19,G9))","v":0}]
[]
[]
["2007 Maximum Income for IRA Deduction","Taxpayer","Spouse","Actual Taxpayer Amount","Actual Spouse Amount"]
["Single or head of household",55000,null,{"$f":"IF(CY_FS=\"Single\",B25,IF(CY_FS=\"Head of Household\",B25,0))","v":0},0]
["Qualifying widow(er)",75000,null,{"$f":"IF(CY_FS = \"Qualifying Widow(er)\", B26,0)","v":0},0]
["Married filing jointly"]
["If taxpayer covered by retirement plan",null,160000,0,{"$f":"IF(CY_FS = \"Married Filing Jointly\", IF(C10=\"Yes\", IF(D10= \"No\", C28,0),0),0)","v":0}]
["If spouse covered by retirement plan",160000,null,{"$f":"IF(CY_FS = \"Married Filing Jointly\", IF(D10=\"Yes\", IF(C10= \"No\", B29,0),0),0)","v":0},0]
["If neither covered by retirement plan",75000,75000,{"$f":"IF(CY_FS = \"Married Filing Jointly\",IF($C$10=\"No\", IF($D$10 = \"No\", B30,0),0),0)","v":0},{"$f":"IF(CY_FS = \"Married Filing Jointly\",IF($C$10=\"No\", IF($D$10 = \"No\", C30,0),0),0)","v":0}]
["Married filing separately"]
["If lived with spouse during year",10000,null,{"$f":"IF(CY_FS = \"Married Filing Separately\",IF('Planning Input'!$B$8=\"Yes\", Adjustments!B32,0),0)","v":0},0]
["If did not live with spouse during year",55000,null,{"$f":"IF(CY_FS = \"Married Filing Separately\",IF('Planning Input'!$B$8=\"No\", Adjustments!B33,0),0)","v":55000},0]
[]
["2008 Maximum Income for IRA Deduction","Taxpayer","Spouse","Actual Taxpayer Amount","Actual Spouse Amount"]
["Single or head of household",60000,null,{"$f":"IF(NY_FS=\"Single\",B36,IF(NY_FS=\"Head of Household\",B36,0))","v":0},0]
["Qualifying widow(er)",80000,null,{"$f":"IF(NY_FS = \"Qualifying Widow(er)\", B37,0)","v":0},0]
["Married filing jointly"]
["If taxpayer covered by retirement plan",null,160000,0,{"$f":"IF(NY_FS = \"Married Filing Jointly\", IF(C10=\"Yes\", IF(D10= \"No\", C39,0),0),0)","v":0}]
["If spouse covered by retirement plan",160000,null,{"$f":"IF(NY_FS = \"Married Filing Jointly\", IF(D10=\"Yes\", IF(C10= \"No\", B40,0),0),0)","v":0},0]
["If neither covered by retirement plan",80000,80000,{"$f":"IF(NY_FS = \"Married Filing Jointly\",IF($C$10=\"No\", IF($D$10 = \"No\", B41,0),0),0)","v":0},{"$f":"IF(NY_FS = \"Married Filing Jointly\",IF($C$10=\"No\", IF($D$10 = \"No\", C41,0),0),0)","v":0}]
["Married filing separately"]
["If lived with spouse during year",10000,null,{"$f":"IF(NY_FS = \"Married Filing Separately\",IF('Planning Input'!$B$8=\"Yes\", Adjustments!B43,0),0)","v":0},0]
["If did not live with spouse during year",60000,null,{"$f":"IF(NY_FS = \"Married Filing Separately\",IF('Planning Input'!$B$8=\"No\", Adjustments!B44,0),0)","v":60000},0]
[]
[]
["IRA Maximum Deduction",2007,null,2008]
[null,"Taxpayer","Spouse","Taxpayer ","Spouse"]
["Under age 50",3000,3000,4000,4000]
["Age 50 or older",3500,3500,4500,4500]
["Actual",{"$f":"IF(CY_TP_Age <50,B49,B50)","v":3000},{"$f":"IF(CY_SP_Age <50,C49,C50)","v":3000},{"$f":"IF(NY_TP_Age <50,D49,D50)","v":4000},{"$f":"IF(NY_SP_Age <50,E49,E50)","v":4000}]
[]
["Tuition and Fees Deduction",2007,null,2008]
["Tuition and fees paid",{"$f":"'Planning Input'!B38","v":4000},null,{"$f":"'Planning Input'!D38","v":4000}]
[]
["Total income",null,{"$f":"'Planning Input'!C30","v":94009},null,{"$f":"'Planning Input'!E30","v":94009}]
["Adjustments other than tuition and fees deduction",null,{"$f":"'Planning Input'!C37+'Planning Input'!C40+'Planning Input'!C41+'Planning Input'!C42+'Planning Input'!C43+'Planning Input'!C45","v":7090},null,{"$f":"'Planning Input'!E37+'Planning Input'!E40+'Planning Input'!E41+'Planning Input'!E42+'Planning Input'!E43+'Planning Input'!E45","v":7090}]
["Difference",null,{"$f":"C56-C57","v":86919},null,{"$f":"E56-E57","v":86919}]
["Filing status",{"$f":"CY_FS","v":"Married Filing Separately"},null,{"$f":"NY_FS","v":"Married Filing Separately"}]
["Total phaseout amount",{"$f":"IF(B59=\"Married Filing Jointly\", B66,C66)","v":80000},null,{"$f":"IF(D59=\"Married Filing Jointly\", D66,E66)","v":80000}]
["Next level of phaseout",{"$f":"IF(B59=\"Married Filing Jointly\", B67,C67)","v":65000},null,{"$f":"IF(D59=\"Married Filing Jointly\", D67,E67)","v":65000}]
["Tuition and fees deduction",null,{"$f":"IF(C58>B60, 0, IF(C58>B61, MIN(2000, B54),MIN(4000,B54)))","v":0},null,{"$f":"IF(E58>D60,0,IF(E58>D61,MIN(2000,D54),MIN(4000,D54)))","v":0}]
[]
["Phaseout Amounts for Tuition and Fees Deduction",2007,null,2008]
[null,"Married\nFiling Jointly","Other","Married\nFiling Jointly","Other"]
["Total phaseout amount",160000,80000,160000,80000]
["Next level of phaseout",130000,65000,130000,65000]

{"sheet":"Deductions and Exemptions","index":4,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[[5,1,5,2],[5,3,5,4],[31,3,31,4],[31,1,31,2],[17,0,17,5],[24,0,24,5]]}
[{"$f":"'Planning Input'!A1","v":"[Name]"}]
["2008 Year-End Tax Planning: Standard Deduction, Itemized Deductions, and Exemptions"]
[{"$f":"'Planning Input'!A3","v":"[Date]"}]
[]
["You do not need to enter anything into shaded cells.",null,null,null,"CONFIDENTIAL"]
["Allowed Itemized Deductions",2007,null,2008]
["Total itemized deductions",null,{"$f":"'Planning Input'!C62","v":11987},null,{"$f":"'Planning Input'!E62","v":11987}]
["Medical, investment interest, and casualty",null,{"$f":"'Planning Input'!C51+'Planning Input'!C56+'Planning Input'!C58","v":0},null,{"$f":"'Planning Input'!E51+'Planning Input'!E56+'Planning Input'!E58","v":0}]
["Difference (if 0, all allowed)",null,{"$f":"C7-C8","v":11987},null,{"$f":"E7-E8","v":11987}]
["Difference multiplied by 0.80",{"$f":"IF(C9=0, \"\", ROUND(C9*0.8,0))","v":9590},null,{"$f":"E9*0.8","v":9589.6}]
["Adjusted gross income",{"$f":"'Planning Input'!C47","v":86919},null,{"$f":"'Planning Input'!E47","v":86919}]
["Threshold for itemized deduction phaseout",{"$f":"IF(C9=0, \"\", IF(CY_FS=\"Married Filing Separately\",71350,142000))","v":71350},null,{"$f":"IF(E9=0, \"\", IF(NY_FS=\"Married Filing Separately\",72975,145950))","v":72975}]
["Excess (if 0 or less, all allowed)",{"$f":"IF(C9=0, \"\", B11-B12)","v":15569},null,{"$f":"IF(E9=0, \"\", D11-D12)","v":13944}]
["Multiply excess by 0.03",{"$f":"IF(C9=0,\"\",IF(B13<=0,\"\",ROUND(0.03*B13,0)))","v":467},null,{"$f":"IF(E9=0,\"\",IF(D13<=0,\"\",0.03*D13))","v":418.32}]
["Smaller of 80% of difference, or 3% of excess",null,{"$f":"IF(C9=0, \"\", IF(B13<=0, \"\", MIN(B10,B14)))","v":467},null,{"$f":"IF(E9=0, \"\", IF(D13<=0, \"\", MIN(D10,D14)))","v":418.32}]
["Allowed itemized deductions",null,{"$f":"IF(C9=0, C7, IF(B13<=0, C7,C7-C15))","v":11520},null,{"$f":"IF(E9=0, E7, IF(D13<=0, E7,E7-E15))","v":11568.68}]
[]
["2007 Standard Deduction"]
[null,"Regular","Over Age 65 or Blind","Regular Deduction","Additional Deduction for Age","Additional Deduction for Blindness"]
["Married filing jointly or qualifying widow(er)",9700,950,{"$f":"IF(CY_FS = \"Married Filing Jointly\", B20,IF(CY_FS = \"Qualifying Widow(er)\", B20, 0))","v":0},{"$f":"IF(D20=0,0,IF(CY_TP_Age>64,IF(CY_SP_Age>64,2*C20,C20),0))","v":0},{"$f":"IF(D20=0,0,IF(CY_Blind = \"Both\",2*E20,IF(CY_Blind = \"Taxpayer\", C20,IF(CY_Blind = \"Spouse\",C20,0))))","v":0}]
["Single",4850,1200,{"$f":"IF(CY_FS = \"Single\", B21,0)","v":0},{"$f":"IF(D21=0,0,IF(CY_TP_Age>64,C21,0))","v":0},{"$f":"IF(D21=0,0,IF(CY_Blind = \"Taxpayer\", C21,0))","v":0}]
["Head of household",7150,1200,{"$f":"IF(CY_FS = \"Head of Household\", B22,0)","v":0},{"$f":"IF(D22=0,0,IF(CY_TP_Age>64,C22,0))","v":0},{"$f":"IF(D22=0,0,IF(CY_Blind = \"Taxpayer\", C22,0))","v":0}]
["Married filing separately",4850,950,{"$f":"IF(CY_FS = \"Married Filing Separately\", B23,0)","v":4850},{"$f":"IF(D23=0,0,IF(CY_TP_Age>64,C23,0))","v":0},{"$f":"IF(D23=0,0,IF(CY_Blind = \"Taxpayer\", C23,0))","v":0}]
[]
["2008 Standard Deduction"]
[null,"Regular","Over Age 65 or Blind","Regular Deduction","Additional Deduction for Age","Additional Deduction for Blindness"]
["Married filing jointly or qualifying widow(er)",10000,1000,{"$f":"IF(NY_FS = \"Married Filing Jointly\", B27,IF(NY_FS = \"Qualifying Widow(er)\", B27, 0))","v":0},{"$f":"IF(D27=0,0,IF(NY_TP_Age>64,IF(NY_SP_Age>64,2*C27,C27),C27))","v":0},{"$f":"IF(D27=0,0,IF(NY_Blind = \"Both\",2*C27,IF(NY_Blind = \"Taxpayer\", C27,IF(NY_Blind = \"Spouse\",C27,0))))","v":0}]
["Single",5000,1250,{"$f":"IF(NY_FS = \"Single\", B28,0)","v":0},{"$f":"IF(D28=0,0,IF(NY_TP_Age>64,C28,0))","v":0},{"$f":"IF(D28=0,0,IF(NY_Blind = \"Taxpayer\", C28,0))","v":0}]
["Head of household",7300,1250,{"$f":"IF(NY_FS = \"Head of Household\", B29,0)","v":0},{"$f":"IF(D29=0,0,IF(NY_TP_Age>64,C29,0))","v":0},{"$f":"IF(D29=0,0,IF(NY_Blind = \"Taxpayer\", C29,0))","v":0}]
["Married filing separately",5000,1000,{"$f":"IF(NY_FS = \"Married Filing Separately\", B30,0)","v":5000},{"$f":"IF(D30=0,0,IF(NY_TP_Age>64,C30,0))","v":0},{"$f":"IF(D30=0,0,IF(NY_Blind = \"Taxpayer\", C30,0))","v":0}]
[]
["Exemptions",2007,null,2008]
["Amount per exemption",3100,null,3200]
["Exemption Calculation:"]
["Taxpayer and spouse personal exemption",{"$f":"IF(CY_FS =\"Married Filing Jointly\", 2*CY_Exemption_Amount, CY_Exemption_Amount)","v":3100},null,{"$f":"IF(NY_FS =\"Married Filing Jointly\", 2*NY_Exemption_Amount, NY_Exemption_Amount)","v":3200}]
["Dependent exemptions",{"$f":"'Planning Input'!B12*'Deductions and Exemptions'!B33","v":3100},null,{"$f":"'Planning Input'!D12*'Deductions and Exemptions'!D33","v":3200}]
["Total available exemptions",null,{"$f":"SUM(B35:B36)","v":6200},null,{"$f":"SUM(D35:D36)","v":6400}]
["Adjusted gross income",{"$f":"'Planning Input'!C47","v":86919},null,{"$f":"'Planning Input'!E47","v":86919}]
["Amount for filing status from table below",{"$f":"IF(CY_FS=\"Married Filing Jointly\",'Deductions and Exemptions'!B47,IF(CY_FS=\"Qualifying Widow(er)\",'Deductions and Exemptions'!B47,IF(CY_FS=\"Single\",'Deductions and Exemptions'!B48,IF(CY_FS=\"Head of Household\",'Deductions and Exemptions'!B49,IF(CY_FS=\"Married Filing Separately\",'Deductions and Exemptions'!B50,0)))))","v":107025},null,{"$f":"IF(NY_FS=\"Married Filing Jointly\",'Deductions and Exemptions'!D47,IF(NY_FS=\"Qualifying Widow(er)\",'Deductions and Exemptions'!D47,IF(NY_FS=\"Single\",'Deductions and Exemptions'!D48,IF(NY_FS=\"Head of Household\",'Deductions and Exemptions'!D49,IF(NY_FS=\"Married Filing Separately\",'Deductions and Exemptions'!D50,0)))))","v":109475}]
["Difference",{"$f":"MAX(0, B38-B39)","v":0},null,{"$f":"MAX(0, D38-D39)","v":0}]
["Difference divided",{"$f":"IF(B40>122500, 0, IF('Planning Input'!B7=\"Married Filing Separately\",ROUNDUP('Deductions and Exemptions'!B40/1250,0),ROUNDUP('Deductions and Exemptions'!B40/2500,0)))","v":0},null,{"$f":"IF(D40>122500, 0, IF(NY_FS=\"Married Filing Separately\",ROUNDUP('Deductions and Exemptions'!D40/1250,0),ROUNDUP('Deductions and Exemptions'!D40/2500,0)))","v":0}]
["Multiply by 0.02",{"$f":"B41*0.02","v":0},null,{"$f":"D41*0.02","v":0}]
["Multiply line above by total available exemptions",null,{"$f":"ROUND(B42*C37,0)","v":0},null,{"$f":"ROUND(D42*E37,0)","v":0}]
["Allowed exemptions",null,{"$f":"C37-C43","v":6200},null,{"$f":"E37-E43","v":6400}]
[]
["Phaseout Amounts for Exemptions",2007,null,2008]
["Married filing jointly or qualifying widow(er)",214050,null,218950]
["Single",142700,null,145950]
["Head of household",178350,null,182450]
["Married filing separately",107025,null,109475]

{"sheet":"Tax Calculations","index":5,"n_rows":114,"n_cols":9,"rows_kept":114,"cut":false,"hidden":false,"merged":[[5,0,5,4],[19,0,19,6],[27,0,27,6],[35,0,35,6],[60,0,60,6],[68,0,68,6],[85,2,85,5],[85,6,85,8],[76,0,76,6],[43,0,43,6],[52,0,52,6],[90,2,90,3],[91,2,91,3],[92,2,92,3],[93,2,93,3],[86,2,86,3],[87,2,87,3],[88,2,88,3],[89,2,89,3],[98,2,98,3],[99,2,99,3],[100,2,100,3],[101,2,101,3],[94,2,94,3],[95,2,95,3],[96,2,96,3],[97,2,97,3],[106,2,106,3],[107,2,107,3],[108,2,108,3],[102,2,102,3],[103,2,103,3],[104,2,104,3],[105,2,105,3]]}
[{"$f":"'Planning Input'!A1","v":"[Name]"}]
["2008 Year-End Tax Planning: Tax Calculations"]
[{"$f":"'Planning Input'!A3","v":"[Date]"}]
[]
["You do not need to enter anything into shaded cells.",null,null,null,null,"CONFIDENTIAL"]
["Self-Employment (SE) Tax"]
[null,null,2007,null,2008]
["Maximum earnings",null,87900,null,90000]
["Social Security tax rate",null,0.124,null,0.124]
["Medicare tax rate",null,2.9000000000000001E-2,null,2.9000000000000001E-2]
["Self-employment income",null,{"$f":"'Planning Input'!C21","v":57000},null,{"$f":"'Planning Input'!E21","v":57000}]
["Net earnings from self-employment",null,{"$f":"MIN(B8,C11*0.9235)","v":52639.5},null,{"$f":"MIN(E8,E11*0.9235)","v":52639.5}]
[]
["Social Security tax",null,{"$f":"ROUND(C12*C9,0)","v":6527},null,{"$f":"ROUND(E12*E9, 0)","v":6527}]
["Medicare tax",null,{"$f":"ROUND(C11*C10,0)","v":1653},null,{"$f":"ROUND(E11*E10, 0)","v":1653}]
["Total self-employment tax",null,{"$f":"C14+C15","v":8180},null,{"$f":"E14+E15","v":8180}]
[]
[]
["2007 Individual Income Tax"]
["Married filing jointly (MFJ) or qualifying widow(er) (QW) taxable income"]
[0,"--",14300,"×",0.1,"minus",0]
[14301,"--",58100,"×",0.15,"minus",715]
[58101,"--",117250,"×",0.25,"minus",6525]
[117251,"--",178650,"×",0.28000000000000003,"minus",10042.5]
[178651,"--",319100,"×",0.33,"minus",18975]
[319101,"--",null,"×",0.35,"minus",25357]
[]
["Single taxable income"]
[0,"--",7150,"×",0.1,"minus",0]
[7151,"--",29050,"×",0.15,"minus",357.5]
[29051,"--",70350,"×",0.25,"minus",3262.5]
[100000,"--",146750,"×",0.28000000000000003,"minus",5373]
[146751,"--",319100,"×",0.33,"minus",12710.5]
[319101,"--",null,"×",0.35,"minus",19092.5]
[]
["Head of household (HOH) taxable income"]
[0,"--",10200,"×",0.1,"minus",0]
[10201,"--",38900,"×",0.15,"minus",510]
[38901,"--",100500,"×",0.25,"minus",4400]
[100501,"--",162700,"×",0.28000000000000003,"minus",7415]
[162701,"--",319100,"×",0.33,"minus",15550]
[319101,"--",null,"×",0.35,"minus",21932]
[]
["Married filing separately (MFS) taxable income"]
[0,"--",7150,"×",0.1,"minus",0]
[7151,"--",29050,"×",0.15,"minus",357.5]
[29051,"--",58625,"×",0.25,"minus",3262.5]
[58626,"--",89325,"×",0.28000000000000003,"minus",5021.25]
[89326,"--",159550,"×",0.33,"minus",9487.5]
[159551,"--",null,"×",0.35,"minus",12678.5]
[]
["2008 Individual Income Tax"]
["Married filing jointly (MFJ) or qualifying widow(er) (QW) taxable income"]
[0,"--",14600,"×",0.1,"minus",0]
[14601,"--",59400,"×",0.15,"minus",730]
[59401,"--",119950,"×",0.25,"minus",6670]
[119951,"--",182800,"×",0.28000000000000003,"minus",10268.5]
[182801,"--",326450,"×",0.33,"minus",19408.5]
[326451,"--",null,"×",0.35,"minus",25937.5]
[]
["Single taxable income"]
[0,"--",7300,"×",0.1,"minus",0]
[7301,"--",29700,"×",0.15,"minus",365]
[29701,"--",71950,"×",0.25,"minus",3335]
[71951,"--",150150,"×",0.28000000000000003,"minus",5493.5]
[150151,"--",326450,"×",0.33,"minus",13001]
[326451,"--",null,"×",0.35,"minus",19530]
[]
["Head of household (HOH) taxable income"]
[0,"--",10450,"×",0.1,"minus",0]
[10451,"--",39800,"×",0.15,"minus",522.5]
[39801,"--",102800,"×",0.25,"minus",4502.5]
[102801,"--",166450,"×",0.28000000000000003,"minus",7586.5]
[166451,"--",326450,"×",0.33,"minus",15909]
[326451,"--",null,"×",0.35,"minus",22438]
[]
["Married filing separately (MFS) taxable income"]
[0,"--",7300,"×",0.1,"minus",0]
[7301,"--",29700,"×",0.15,"minus",365]
[29701,"--",59975,"×",0.25,"minus",3335]
[59976,"--",91400,"×",0.28000000000000003,"minus",5134.25]
[91401,"--",163225,"×",0.33,"minus",9704.25]
[163226,"--",null,"×",0.35,"minus",12968.75]
[]
[]
["Capital Gains Tax",null,2007,null,null,null,2008]
["1. Taxable income",null,null,null,{"$f":"CY_TaxIncome","v":69199},null,null,{"$f":"NY_TaxIncome","v":68950}]
["2. Qualified dividends",null,{"$f":"'Planning Input'!B19","v":0},null,null,null,{"$f":"'Planning Input'!D19","v":0}]
["3. Capital gains",null,{"$f":"'Planning Input'!C22","v":-3000},null,null,null,{"$f":"'Planning Input'!E22","v":-3000}]
["4. Dividends and capital gains",null,{"$f":"C88+C89","v":-3000},null,null,null,{"$f":"G88+G89","v":-3000}]
["5. Investment interest expense",null,{"$f":"'Planning Input'!C56","v":0},null,null,null,{"$f":"'Planning Input'!E56","v":0}]
["6. Net dividends and capital gains",null,null,null,{"$f":"MAX(0,C90-C91)","v":0},null,null,{"$f":"MAX(0, G90-G91)","v":0}]
["7. Taxable income less line 6",null,null,null,{"$f":"MAX(0, E87-E92)","v":69199},null,null,{"$f":"MAX(0, H87-H92)","v":68950}]
["8. Enter the smaller of:"]
["The amount on line 1, or"]
["$29,050 if single or MFS,"]
["$58,100 if MFJ or QW,"]
["$38,900 if HOH",null,null,null,{"$f":"MIN(E87, IF(CY_FS = \"\", \"\",IF(CY_FS=\"Single\",29050,IF(CY_FS=\"Married Filing Separately\",29050,IF(CY_FS = \"Married Filing Jointly\", 58100, IF(CY_FS = \"Qualifying Widow(er)\", 58100, IF(CY_FS = \"Head of Household\", 38900, 0)))))))","v":29050},null,null,{"$f":"MIN(H87, IF(NY_FS = \"\", \"\",IF(NY_FS=\"Single\",29050,IF(NY_FS=\"Married Filing Separately\",29050,IF(NY_FS = \"Married Filing Jointly\", 58100, IF(NY_FS = \"Qualifying Widow(er)\", 58100, IF(NY_FS = \"Head of Household\", 38900, 0)))))))","v":29050}]
["9. If line 7 < line 8, amount from line 7",null,null,null,{"$f":"IF(E93<E98, E93, \"\")","v":""},null,null,{"$f":"IF(H93<H98, H93, \"\")","v":""}]
["10. Subtract line 9 from line 8",null,null,null,{"$f":"IF(E93>=E98, \"\",E98-E99)","v":""},null,null,{"$f":"IF(H93>=H98, \"\",H98-H99)","v":""}]
["11. Multiply line 10 by 5%",null,null,null,null,{"$f":"IF(E93>=E98, \"\", ROUND(E100*0.05,0))","v":""}]
["12. If line 6 not equal to line 10, \n      smaller of line 1 or line 6",null,null,null,{"$f":"IF(E93>=E98,MIN(E87,E92), IF(E92=E100, \"\", MIN(E87, E92)))","v":0},null,null,{"$f":"IF(H93>=H98,MIN(H87,H92), IF(H92=H100, \"\", MIN(H87, H92)))","v":0}]
["13. Amount on line 10",null,null,null,{"$f":"IF(E92=E100, \"\", IF(E100=\"\", 0, E100))","v":0},null,null,{"$f":"IF(H92=H100, \"\", IF(H100=\"\", 0, H100))","v":0}]
["14. Subtract line 13 from line 12",null,null,null,{"$f":"IF(E92=E100, \"\", E102-E103)","v":0},null,null,{"$f":"IF(H92=H100, \"\", H102-H103)","v":0}]
["15. Multiply line 14 by 15%",null,null,null,null,{"$f":"IF(E92=E100, \"\", IF(E104=\"\", \"\", ROUND(E104*0.15,0)))","v":0},null,null,{"$f":"IF(H92=H100, \"\", IF(H104=\"\", \"\", ROUND(H104*0.15,0)))","v":0}]
["16. Tax on amount on line 7",null,null,null,null,14354,null,null,14172]
["17. Add lines 11, 15, and 16",null,null,null,null,{"$f":"IF(F101 =\"\", IF(F105 = \"\", F106, F105 + F106), IF(F105=\"\", F101+F106, F101+F105+F106))","v":14354},null,null,{"$f":"IF(I101 = \"\", IF(I105 = \"\", I106, I105 + I106), IF(I105=\"\", I101+I106, I101+I105+I106))","v":14172}]
["18. Tax on amount on line 1",null,null,null,null,14219,null,null,14172]
["19. Tax on all taxable income",null,null,null,null,{"$f":"MIN(F107,F108)","v":14219},null,null,{"$f":"MIN(I107,I108)","v":14172}]
[]
["Effective and Marginal Tax Rates",null,2007,null,2008]
["Effective tax rate",null,{"$f":"IF(CY_TaxIncome = 0, 0, F109/CY_TaxIncome)","v":0.20547984797468172},null,{"$f":"IF(NY_TaxIncome=0,0,I109/NY_TaxIncome)","v":0.20554024655547498}]
["Marginal tax rate",null,0.28000000000000003,null,0.28000000000000003]
[{"$f":"IF('Planning Summary'!B13=0, \"\", \"Marginal tax rate: Self-employment income\")","v":"Marginal tax rate: Self-employment income"},null,{"$f":"C113+'Tax Calculations'!C9+'Tax Calculations'!C10","v":0.43300000000000005},null,{"$f":"E113+'Tax Calculations'!E9+'Tax Calculations'!E10","v":0.43300000000000005}]

{"sheet":"Credits","index":6,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[[5,1,5,2],[5,3,5,4],[23,0,23,2]]}
[{"$f":"'Planning Input'!A1","v":"[Name]"}]
["2008 Year-End Tax Planning: Credits"]
[{"$f":"'Planning Input'!A3","v":"[Date]"}]
[]
["Gray cells are calculated for you. You do not need to enter anything in them.",null,null,null,"CONFIDENTIAL"]
["Child Tax Credit",2007,null,2008]
["Maximum credit per child",1000,null,1000]
["Number of qualifying children × maximum amount",{"$f":"'Planning Input'!B13*B7","v":1000},null,{"$f":"'Planning Input'!D13*D7","v":1000}]
["Phaseout",{"$f":"B23","v":1000},null,{"$f":"C23","v":1000}]
["Maximum credit available",null,{"$f":"B8-B9","v":0},null,{"$f":"D8-D9","v":0}]
["Tax",{"$f":"CY_Tax","v":14354},null,{"$f":"NY_Tax","v":14172}]
["Certain other credits",{"$f":"SUM('Planning Input'!B73:B77)","v":0},null,{"$f":"SUM('Planning Input'!D73:D77)","v":0}]
["If tax does not equal credits, difference",null,{"$f":"MAX(0,B11-B12)","v":14354},null,{"$f":"MAX(0, D11-D12)","v":14172}]
["Smaller of tax or maximum credit",null,{"$f":"MIN(C10,C13)","v":0},null,{"$f":"MIN(E10,E13)","v":0}]
[]
[]
["Child Tax Credit AGI Phaseout",2007,2008]
["Adjusted gross income",{"$f":"'Planning Input'!C47","v":86919},{"$f":"'Planning Input'!E47","v":86919}]
["Filing status",{"$f":"CY_FS","v":"Married Filing Separately"},{"$f":"NY_FS","v":"Married Filing Separately"}]
["Number of children eligible",{"$f":"'Planning Input'!B13","v":1},{"$f":"'Planning Input'!D13","v":1}]
["Beginning phaseout",{"$f":"IF(B19=\"Married Filing Jointly\", B26,IF(B19=\"Married Filing Separately\",B28,B27))","v":55000},{"$f":"IF(NY_FS=\"Married Filing Jointly\", C26,IF(NY_FS = \"Married Filing Separately\",C28,C27))","v":55000}]
["Ending phaseout",{"$f":"IF(B20=1,B21+((B8/5*50)-999),IF(B20>1,B21+((B8/5*50)-999)+((B20-1)*(B8/5*50)),0))","v":64001},{"$f":"IF(C20=1,C21+((D8/5*50)-999),IF(C20>1,C21+((D8/5*50)-999)+((C20-1)*(D8/5*50)),0))","v":64001}]
["Actual phaseout",{"$f":"IF(B18<B21,0,IF(B18>B22,B8,(ROUNDUP((B18-B21),-3)/1000)*50))","v":1000},{"$f":"IF(C18<C21,0,IF(C18>C22,D8,(ROUNDUP((C18-C21),-3)/1000)*50))","v":1000}]
[]
["Filing Status","2007 Beginning\nAGI Phaseout","2008 Beginning\nAGI Phaseout"]
["Married filing jointly",110000,110000]
["Single, head of household, qualified widow(er)",75000,75000]
["Married filing separately",55000,55000]